Seattle AirBnB Insights

In this Tableau project, analysis is done on data of AirBnB listings in Seattle. Here is a step to step walk through of the project.

  1. An Overview of the Data

    2. The data is stored in an excel workbook and we open it to study and understand our data.

    Fullscreen Image
    ✖

  2. Importing data into Tableau

    3. After studying and understanding our data, we load it into Tableau. We then join the three sheets in the data together.

    Fullscreen Image
    ✖

  3. Price by Zipcode

    4. After joining the data, I loaded the data and began with the analysis. The first analysis involved creating a bar graph to determine the average price of AirBnBs in the various zipcodes in Seattle. This information is useful for a business person that might be looking to start the airBnB business in the area.

    Fullscreen Image
    ✖

  4. Zipcode Mapping

    5. I then created a mapping of the various zipcodes. This was to determine the precise location of the zipcodes in the previous analysis.

    Fullscreen Image
    ✖

  5. Revenue over the Year

    6. The investor is then interested to know how demand is over the year. We create a graph to determine at which period of the year people are mostly renting AirBnBs.

    Fullscreen Image
    ✖

  6. Average Price per Bedroom

    7. I then determined the average price of AirBnBs based on the number of bedrooms. This is helpful to determine which have the highest return.

    Fullscreen Image
    ✖

  7. Count of Bedroom listing

    8. Finally, I did a distinct count of listings based on the number of bedrooms. This is useful to determine the competition.

    Fullscreen Image
    ✖

  8. Creating a Dashboard

    9. Finally I create a dashboard where I put all the visualizations together.

    Fullscreen Image
    ✖

    To download and view the full project on GitHub, click here.